select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseprice >= 30000 and a.houseprice <= 40000) and c.enDistrictName = 'Minhang' and b.pid in (select x.pid from [base_property] x,[base_districtArea] y where x.aid=y.id and y.enAreaName = 'Huacao Town') order by updateTime Desc, a.dftpic desc
Fully furnishing, electrical appliances, floor heating, central air conditioner, hood, stove, dishwasher, oven, central water purifier, satellite receiver etc.
It is an amazing single-family lane house with three floors with one floor basement, newly renovated with elegant decoration.This house's highlights include a b...
Luxury decoration, the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good l...